package com.situ.water_BE.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.situ.water_BE.pojo.BeHistory;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author Angel
 * @since 2020-12-01
 */
@Mapper
public interface BeHistoryMapper extends BaseMapper<BeHistory> {
    @Override
    public int insert(BeHistory beHistory);
    @Select("SELECT h.datee,f.stepName,e.empNmae,h.isBack FROM be_history h,sy_emp e,be_flow f " +
            "where h.StepID=f.id and h.EmpID=e.id and h.OrderNo=#{orderNo}")
    public List<Map> queryAllBeHistory(String orderNo);
}
